﻿using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Linq;
using University.Workshop.Model;
using System.Data.Entity;
namespace University.Workshop.DataAccess
{
    public class WFPEntities : DbContext
    {
        private static WFPEntities instance;
        
        public WFPEntities()
            : base("WFPDB1")
        {
            //this.Database.Connection.ConnectionString = @"Data Source=.\SQLE; Initial Catalog=WFDB; Integrated Security=true";

            if (!this.Database.Exists())
            {
                this.Database.CreateIfNotExists();

                #region Admin user
                this.Person.Add(new Person() { Names = "Admin", LastNames = "Admin", PersonId = "0", Phone = "" });

                this.User.Add(new User() { UserId = "0", Login = "admin", Role = 0, IsActive = true, Password = "admin" });

                SaveChanges();
                #endregion

                #region Phalta Orko datos
                //this.Person.Add(new Person() { Names = "Ivan", LastNames = "MONTES  FABRICA", PersonId = "7909322 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Leandro", LastNames = "SERRUDO FERNANDEZ", PersonId = "4096605 CH", Phone = "" });
                //this.Person.Add(new Person() { Names = "Jorge", LastNames = "CONDORI CHOQUE  ", PersonId = "5243655 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Paulina", LastNames = "GARCIA HURTADO", PersonId = "4447889 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Johny", LastNames = "VEIZAGA  AVILEZ  ", PersonId = "5317593 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Beatris", LastNames = "HUARITA CASTELLON", PersonId = "6414994 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Emilio", LastNames = "BARRIOS  ROJAS ", PersonId = "4444514 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Nora", LastNames = "RODRIGUEZ NOGALES", PersonId = "3612299 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Alfredo", LastNames = "MAMANI TINTAYA", PersonId = "3481755 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Herminia", LastNames = "ROMAN  FLORES ", PersonId = "5208273 NCB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Karina Getrudes", LastNames = "FELIPE TARQUE", PersonId = "8018707 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Teofilo", LastNames = "LOPES  CALLACOPA ", PersonId = "3573123 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Luis", LastNames = "MARIN  SILES ", PersonId = "5295577 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Valerio", LastNames = "ROJAS MARIN", PersonId = "5256229 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ninfa", LastNames = "ROJAS  MARIN ", PersonId = "7964874 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juanita", LastNames = "DURAN ALVARADO ", PersonId = "5260491 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Sabina", LastNames = "ORDOÑEZ   FLORES", PersonId = "5553483 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ronald", LastNames = "MAMANI  CONDORI ", PersonId = "9323480 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Serafina", LastNames = "ENCINAS ", PersonId = "4415012 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ruben", LastNames = "BALTAZAR BALDERRAMA", PersonId = "6443037 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Francisco", LastNames = "RODRIGUEZ KARI KARI", PersonId = "5301610 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Brigida", LastNames = "RIVERA  CATORCENO ", PersonId = "7881054 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Luz Edid", LastNames = "LOZADA VASQUEZ", PersonId = "982326 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Emiliana", LastNames = "CORTEZ  AGUILAR DE  APAZA ", PersonId = "686428 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Miguel", LastNames = "FLORES BURGOS", PersonId = "7521440 CH", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maximiliano", LastNames = "ROMAN ENCINAS ", PersonId = "4498493 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Miguelina", LastNames = "TORRICO  de  HERRERA", PersonId = "3155567 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Deciderio", LastNames = "FLORES PADILLA", PersonId = "4505140 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Veronica", LastNames = "DAZA ARGANDOÑA ", PersonId = "5151737 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Nemesia", LastNames = "HERRERA  de  GONZALES ", PersonId = "4479951 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Lucio", LastNames = "OVANDO  FLORES ", PersonId = "3761046 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maximo", LastNames = "RODRIGUEZ  MEDINA  ", PersonId = "6457612 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Sandra Marlene", LastNames = "MARLENE  PEREZ  AVILEZ  ", PersonId = "5152801 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cristobal", LastNames = "CHOQUE CALA", PersonId = "6536604 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Marcelo", LastNames = "TITO  COPATITI", PersonId = "5231767 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Felicidad", LastNames = "VEIZAGA  AVILEZ ", PersonId = "5283506 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Pascual", LastNames = "OJEDA CAMACHO", PersonId = "3760721 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Bilma", LastNames = "RENGEL  LAURA ", PersonId = "3547439 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juan Pablo", LastNames = "CHOQUE ZEBALLOS", PersonId = "7948195 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Paulina", LastNames = "MOLINA JALDIN ", PersonId = "2908036 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Norma", LastNames = "RODRIGUEZ  OLIVERA ", PersonId = "7944542 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Jose Giony", LastNames = "MUNACHI  CONDORI ", PersonId = "5909062 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Eugenio", LastNames = "TERRAZAS  CRUZ ", PersonId = "4436615 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ana Maria", LastNames = "RAMOS  LEPIQUE  ", PersonId = "5933096 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juan", LastNames = "QUISPE MAMANI", PersonId = "5909590 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Felix", LastNames = "MONTAÑO   ARIAS ", PersonId = "7971798 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Eduardo", LastNames = "QUIROGA  ROJAS ", PersonId = "7870820 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Isidro", LastNames = "PONCE  COLQUE  ", PersonId = "5157742 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ezequiel", LastNames = "ROSAS ", PersonId = "5272938 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Andrea", LastNames = "HUALLATA CHOQUETICLLA", PersonId = "3081925 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cecilio Felipe", LastNames = "FLORES", PersonId = "3001920 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Avigail Esther", LastNames = "LIZITE ZEPITA", PersonId = "3558299 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Martina", LastNames = "FIESTA  PADILLA ", PersonId = "6536646 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Medarda", LastNames = "GUZMAN SOTO", PersonId = "3868468 SC", Phone = "" });
                //this.Person.Add(new Person() { Names = "Bacilia", LastNames = "MERCADO CAMPOS", PersonId = "6553725 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cirilo", LastNames = "FERNANDEZ ALBARRACIN", PersonId = "6501681 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Olga Prima", LastNames = "ALIAGA CONDORI", PersonId = "5422479 ZC", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cirilo", LastNames = "RODRIGUEZ  PEREIRA ", PersonId = "3592998 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Placido", LastNames = "ALVARES VELARDE  ", PersonId = "5263361 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Victor", LastNames = "HUALLPA VILLCA         *", PersonId = "3636033 CH", Phone = "" });
                //this.Person.Add(new Person() { Names = "Irenia", LastNames = "OLIVERA VARGAS", PersonId = "6451211 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juan Carlos", LastNames = "MEDRANO", PersonId = "3619376 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Dora", LastNames = "LARA ALVAREZ", PersonId = "4680817 ZC", Phone = "" });
                //this.Person.Add(new Person() { Names = "Raimunda", LastNames = "MOYA RICALDEZ ", PersonId = "3623573 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maribel", LastNames = "ZAPATA ZURITA  ", PersonId = "8050961 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Isaura", LastNames = "CADIMA VEIZAGA", PersonId = "6440839 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Franz Wilfredo", LastNames = "VEIZAGA  CADIMA ", PersonId = "6532314 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Jeffer Alain", LastNames = "AJHUACHO  CHOQUE ", PersonId = "5907166 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Trifonia", LastNames = "VELARDE  VASQUEZ ", PersonId = "4441716 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Milta", LastNames = "FUENTES DE GUZMAN", PersonId = "4532345 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Clemente", LastNames = "CALLE MENDEZ", PersonId = "2396867 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Margara", LastNames = "MORALES COLQUE", PersonId = "7968125 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Calixto", LastNames = "ROJAS GUTIERREZ", PersonId = "5273837 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Eulogio", LastNames = "ALANOCA CUICO", PersonId = "6543748 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Fernando", LastNames = "ALACA  PINTO ", PersonId = "8047522 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Gumercindo", LastNames = "VASQUEZ  MEDRANO   ", PersonId = "3051916 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Virgilio", LastNames = "CUELA CORNEJO", PersonId = "8055388 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Delma", LastNames = "PARADA  MONDOCORRE ", PersonId = "6616059 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Pablo", LastNames = "HERRERA MARIN", PersonId = "882271 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Lucia", LastNames = "PAUCARA DE SUNABIA", PersonId = "2385367 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Zulma", LastNames = "ANTEZANA OLIVERA", PersonId = "7888302 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juana", LastNames = "ESPEJO VEGA ", PersonId = "5259402 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Felix", LastNames = "ROSAS SORIA", PersonId = "2901664 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Mauro", LastNames = "RODRIGUEZ ROJAS", PersonId = "6529607 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Sixto", LastNames = "RODRIGUEZ ROJAS", PersonId = "6412272 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Agustina", LastNames = "COSSIO  AYAVIRI", PersonId = "7947353 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Macedonio", LastNames = "HERBAS FLORES", PersonId = "6522393 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Margarita", LastNames = "FLORES COLQUE", PersonId = "7882637 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Apolinaria", LastNames = "YUCRA CHOQUE ", PersonId = "4380874 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Anselmo", LastNames = "RICALDES CASERES", PersonId = "6534835 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Berhto", LastNames = "ESCOBAR CORRALES", PersonId = "6478656 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Susana", LastNames = "ESPEJO VEGA", PersonId = "5504465 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Claudia", LastNames = "ESPEJO", PersonId = "6665622 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Hilarion", LastNames = "MAMANI TAQUICHIRI", PersonId = "5128843 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Hugo", LastNames = "MAMANI TAQUICHIRI", PersonId = "6633838 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Eduwar", LastNames = "FERNANDES MUNACHI", PersonId = "5317691 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ronald", LastNames = "MARIN ", PersonId = "7998285 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Aurelio", LastNames = "RIOS RODRIGUEZ ", PersonId = "7892874 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Dora", LastNames = "ROSAS CASTELLON", PersonId = "7987033 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Elba", LastNames = "SILES DE MONTAÑO", PersonId = "976078 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Adriana", LastNames = "SOLARES MARTINEZ", PersonId = "6551827 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Aurora", LastNames = "GARCIA PARRA", PersonId = "4446344 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Gabriela", LastNames = "PARRA ARNEZ DE LOPEZ", PersonId = "3580589 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ana Maria", LastNames = "GLORIA  CAMACHO PEREZ ", PersonId = "3575890 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cristina", LastNames = "VARGAS LIMACHI", PersonId = "9373449 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Julian", LastNames = "VIDAL MELENDRES", PersonId = "3593414 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Anacleta", LastNames = "GONZALES  VEIZAGA ", PersonId = "896201 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Praxedes", LastNames = "RIVERA ACHO", PersonId = "3751356 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rosemery", LastNames = "GUZMAN GONZALES", PersonId = "4536751 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Nemesio", LastNames = "ÑUCRA  CONDORI ", PersonId = "731382 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Jacinto", LastNames = "FLORES AVENTAÑO  ", PersonId = "5116615 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Benita", LastNames = "SALINAS MANCHANI", PersonId = "6402182 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Esteban", LastNames = "CALANI MAMANI", PersonId = "5262716 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Carlos Ascencio", LastNames = "ACHA  DIAZ  ", PersonId = "6442234 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Alfredo", LastNames = "CAMACHO PEREZ ", PersonId = "3615251 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Julia", LastNames = "PEREZ  ARDAYA  de  CAMACHO ", PersonId = "737475 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Aurelio", LastNames = "CAMACHO PEÑARRIETA", PersonId = "842807 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Lidia Monica", LastNames = "DURAN COPA ", PersonId = "4427443 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Damiana", LastNames = "DURAN CAMACHO DE LINARES", PersonId = "902123 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Apolonia", LastNames = "QUISPE  MOYA", PersonId = "5215415 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Isidro", LastNames = "CAMPERO FLORES", PersonId = "3614171 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Emeteria", LastNames = "MENDOZA HUAYRA  ", PersonId = "5228372 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juan", LastNames = "MAMANI SUYO", PersonId = "3980293 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Silvestre", LastNames = "ROJAS BALDERRAMA", PersonId = "3569771 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Peregrina", LastNames = "VASQUEZ LOPEZ", PersonId = "5284610 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Eulogio", LastNames = "MERIDA DURAN", PersonId = "3747690 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Oscar Roberto", LastNames = "GUSMAN MUJICA", PersonId = "4473984 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Dora Luz", LastNames = "GUZMAN MUJICA", PersonId = "5186319 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Carlos", LastNames = "CAMPOS CRUZ", PersonId = "5213794 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Wilfredo", LastNames = "ARGOLLO GARCIA", PersonId = "5204657 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Teodocia", LastNames = "NICOLAS COLQUE", PersonId = "6459422 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Nancy", LastNames = "ANTORIANO ANTEZANA", PersonId = "3092974 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Sinforosa", LastNames = "CHOQUE GONZALES", PersonId = "3735339 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Willy", LastNames = "VIRGILIO ADUVIRI", PersonId = "4432085 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juana", LastNames = "ARNEZ  CALUCHO ", PersonId = "5299922 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Jenaro", LastNames = "GUTIERREZ PACA", PersonId = "4430834 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Fermina Reina", LastNames = "QUISPE  QUISPE ", PersonId = "4455960 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Roberta", LastNames = "FERNANDEZ DE  PAYARI ", PersonId = "996717 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ancelmo", LastNames = "ARNEZ  MEJIA  ", PersonId = "851009 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Tania", LastNames = "SANTIESTEBAN BORDA ", PersonId = "5202817 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Petrona", LastNames = "CONDORI DE NAVARRO", PersonId = "4502879 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Freddy", LastNames = "KAMPPE  ROMERO ", PersonId = "2454533 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Tania Sonia", LastNames = "SAGARDIA SILES", PersonId = "5157622 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Pascual", LastNames = "AGUIRRE  ROJAS  ", PersonId = "3608695 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cristina Amalia", LastNames = "BLANCO MAMANI", PersonId = "5272704 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Valeriano", LastNames = "ROJAS CASTRO", PersonId = "3153598 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rosa Mari", LastNames = "ENCINAS QUIÑONES", PersonId = "8008991 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Domingo", LastNames = "PAINA", PersonId = "3590418 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Filemon", LastNames = "JACHACOLLO MAMANI", PersonId = "3050115 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Angelina", LastNames = "RODRIGUEZ VALLEJOS", PersonId = "1790035 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Gregorio", LastNames = "MAYTA BARRETO", PersonId = "654074 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Jhonny", LastNames = "POZO LEDEZMA  ", PersonId = "5161332 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Epifanio", LastNames = "CHURA GONZALES", PersonId = "3538440 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Simona", LastNames = "MAMANI CONDORI", PersonId = "10509374 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Excequiel", LastNames = "CACERES TARDIO  ", PersonId = "5180524 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Sofia", LastNames = "MANCILLA  DE PERLAS ", PersonId = "5913931 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Aquilina", LastNames = "APAZA  CORTEZ", PersonId = "3511210 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Antonio", LastNames = "RODRIGUEZ VARGAS", PersonId = "3767565 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Casto", LastNames = "TERCEROS", PersonId = "4507180 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Gregorio", LastNames = "REVOLLO TERCEROS", PersonId = "2862102 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Leonidas", LastNames = "HINOJOSA MORALES", PersonId = "3781518 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Simon", LastNames = "REVOLLO TERCEROS", PersonId = "2901372 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rina Isabel", LastNames = "JIMENEZ  ", PersonId = "4416893 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Humberto", LastNames = "LARA   ALVARES ", PersonId = "4180974 BN", Phone = "" });
                //this.Person.Add(new Person() { Names = "Epifania", LastNames = "LARA  ORELLANA  ", PersonId = "6476647 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Jaime", LastNames = "ZAMBRANA  RODRIGUEZ", PersonId = "4456985 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Herminia", LastNames = "VILLARROEL JALDIN", PersonId = "3724998 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maria Concepcion", LastNames = "RODRIGUEZ  de ZAMBRANA ", PersonId = "5203325 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ambrosia", LastNames = "GASPAR  CUYU ", PersonId = "8797654 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Froilan", LastNames = "FLORES LEDEZMA", PersonId = "952214 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Alejandrina", LastNames = "POZO ROJAS", PersonId = "3758959 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Simon Benito", LastNames = "CHANBI CHANBI", PersonId = "5915261 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Roxana Rosa", LastNames = "FERNANDEZ GARVIZU", PersonId = "3115024 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Norma", LastNames = "ROJAS VALLEJOS", PersonId = "6274341 SC", Phone = "" });
                //this.Person.Add(new Person() { Names = "Sandra", LastNames = "PEDRO VEGA ", PersonId = "6567130 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ricardo", LastNames = "SAIGUA  CRUZ ", PersonId = "3016800 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Eliodoro", LastNames = "HEREDIA FLORES", PersonId = "2877007 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Benigno", LastNames = "MAYTA BARRETO", PersonId = "291779 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Roberto", LastNames = "PEREZ GUZMAN", PersonId = "5301890 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maribel Lupe", LastNames = "ZENTENO ACEBEY", PersonId = "4424549 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maria Esther", LastNames = "ZENTENO ACEBEY", PersonId = "6510871 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Casto", LastNames = "SAAVEDRA VALERO", PersonId = "6555043 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Flora", LastNames = "ROJAS AZCARRAGA ", PersonId = "4498060 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Humberto", LastNames = "ANTEZANA NINA", PersonId = "5155601 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cirilo", LastNames = "ROMAN FLORES", PersonId = "5299112 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Leonor", LastNames = "ARNEZ  CALUCHO ", PersonId = "4500140 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Gabriel", LastNames = "CALIZAYA CRUZ", PersonId = "6592976 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "German", LastNames = "CONDORI CLAURE", PersonId = "4088487 CH", Phone = "" });
                //this.Person.Add(new Person() { Names = "Dario", LastNames = "HIGUERA OROSCO", PersonId = "3752898 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Agustina", LastNames = "RODRIGUEZ", PersonId = "5309990 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Fausto", LastNames = "CANQUI", PersonId = "2156041 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Santos", LastNames = "VIRREIRA RIOJA", PersonId = "4522583 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Pablo", LastNames = "NINA COPA", PersonId = "7889444 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Benigno", LastNames = "MAMANI QUIROZ", PersonId = "3801793 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Leocadio", LastNames = "LAZARTE  PEREDO ", PersonId = "979884 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Miguel", LastNames = "MUNACHI   CONDORI ", PersonId = "4439515 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juvenal", LastNames = "QUISPE ALMENDRAS ", PersonId = "1130229 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Pedro", LastNames = "TERAN  ZAPATA ", PersonId = "3154190 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Pedro", LastNames = "AGUILAR  CUCHO ", PersonId = "3993471 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Zenon", LastNames = "PEREZ  LOPEZ ", PersonId = "3593553 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Barbara", LastNames = "AYAVIRI   VDA DE FERNANDEZ ", PersonId = "2870675 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rose Mari", LastNames = "ROSA MORALES", PersonId = "4296746 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cinda", LastNames = "ALMANZA VILLARROEL", PersonId = "7874402 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Celestino", LastNames = "ROMERO", PersonId = "8830867 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Nora", LastNames = "FLORES de CHAMBI", PersonId = "4499022 CB.", Phone = "" });
                //this.Person.Add(new Person() { Names = "Paulina", LastNames = "YAVO LLANQUI", PersonId = "5238088 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Marina", LastNames = "CALUCHO  de ARNEZ ", PersonId = "4470215 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Lupe Noga", LastNames = "RODRIGUEZ  CARVAJAL ", PersonId = "4469412 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cristian", LastNames = "AZCARRAGA TERAN", PersonId = "3727733 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Erasmo", LastNames = "TERRAZAS CLAROS", PersonId = "800519 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Adelio Adalid", LastNames = "MORALES  CUEVAS ", PersonId = "4539743 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ramiro", LastNames = "FLORES PADILLA", PersonId = "5906246 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Roxana", LastNames = "MONTAÑO VILLARROEL", PersonId = "4508725 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Silvia", LastNames = "MONTAÑO VILLARROEL", PersonId = "4422419 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Mirian", LastNames = "MONTAÑO", PersonId = "7751567 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cristina", LastNames = "CONDORI MELENDRES", PersonId = "2915043 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Walter", LastNames = "JIMENEZ", PersonId = "4398142 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Nelly", LastNames = "PAREDES VELASCO", PersonId = "6432505 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rocio", LastNames = "FERNANDEZ AYAVIRI", PersonId = "4450813 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Casto", LastNames = "CARICARI UGARTE", PersonId = "5913598 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Celedonio", LastNames = "PAULES TERAN", PersonId = "5928900 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Benigna", LastNames = "MENDOZA AYAVIRI", PersonId = "3992584 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Efrain", LastNames = "CASERES CONDORI", PersonId = "5259536 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Felix", LastNames = "ROJAS ARISPE  ", PersonId = "3796950 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Luisa", LastNames = "ROJAS  SOTO ", PersonId = "6428193 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Willy", LastNames = "CAMACHO MAIDA ", PersonId = "7910237 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Flora ", LastNames = "LAZARTE REVOLLO  de CHAVEZ ", PersonId = "4455995 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Isabel", LastNames = "VELA  GONZALES  ", PersonId = "3799044 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Remberto", LastNames = "GUTIERREZ MAIDA", PersonId = "7944418 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maximo", LastNames = "SAAVEDRA VASQUEZ", PersonId = "3763124 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Elisabet", LastNames = "URQUIETA ROSALES", PersonId = "4519770 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juan", LastNames = "LLAVETA MAMANI", PersonId = "6484641 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Carmela", LastNames = "QUISPE ROJAS ", PersonId = "6501790 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Teofilo", LastNames = "VALERIANO TARQUI", PersonId = "2480980 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Saturnino", LastNames = "VEIZAGA", PersonId = "2890383 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Samuel", LastNames = "NINA SULLCA ", PersonId = "3686303 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Protacio", LastNames = "CATORCENO PASCUAL", PersonId = "3728130 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Beatris", LastNames = "ANTORIANO ANTEZANA", PersonId = "5203333 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Anastacio", LastNames = "CHIQUIPA SEGALES", PersonId = "3788175 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Angela", LastNames = "ARNES DE MERINO", PersonId = "6533504 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maxima", LastNames = "MAIDA DE GUTIERREZ", PersonId = "7861367 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Jhonny", LastNames = "FLORES COLQUE", PersonId = "5765721 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Carmen", LastNames = "SOTO  REYES  ", PersonId = "4396468 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Casilda", LastNames = "MERCADO LAIME", PersonId = "5920051 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maria", LastNames = "COLQUE  Vda  de  QUISPE ", PersonId = "2871974 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Marcos", LastNames = "MENDOZA  AYAVIRI ", PersonId = "3043728 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Dolores Huayra", LastNames = "VILLCA DE COYO", PersonId = "1436398 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Gregoria", LastNames = "TORRICO DE CARO", PersonId = "5259652 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Mayary", LastNames = "CUELLAR ARGOTE", PersonId = "6435080 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Hermogenes", LastNames = "LEDEZMA  VEIZAGA ", PersonId = "6421040 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Victoria", LastNames = "CONDORI BERNABE", PersonId = "5535582 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Vidal", LastNames = "MAMANI  CERROGRANDE ", PersonId = "3506628 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Getrudes", LastNames = "RODRIGUEZ DE GUZMAN", PersonId = "3222739 ZC", Phone = "" });
                //this.Person.Add(new Person() { Names = "Sonia", LastNames = "GUZMAN RODRIGUEZ", PersonId = "5194046 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rosmery", LastNames = "ARGOTE SANCHEZ ", PersonId = "5927384 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Wilder", LastNames = "NINA  AIZA", PersonId = "8672312 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Prudencia", LastNames = "SOLIZ  VILLCA ", PersonId = "8733899 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Hernan", LastNames = "GALINDO VEIZAGA", PersonId = "4498205 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rufino", LastNames = "GALINDO ZAPATA", PersonId = "3598409 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Andrea", LastNames = "ROJAS ARISPE ", PersonId = "7964805 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Mauricia", LastNames = "MAIDA  MERINO ", PersonId = "4474510 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rosa", LastNames = "ARNEZ  PEÑA ", PersonId = "3796708 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Macario", LastNames = "ALVARADO GARCIA", PersonId = "2919500 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Modesto", LastNames = "ZELADA ALVARADO", PersonId = "5234009 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Genaro", LastNames = "POMA LIMA", PersonId = "4482220 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Paulina", LastNames = "TOLA  VELIZ ", PersonId = "7936517 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Scarlet Shirley", LastNames = "CAPIONA  PARRA ", PersonId = "5208605 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Eustaquio", LastNames = "REYES LARA", PersonId = "4476739 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Richard", LastNames = "REYES ", PersonId = "5304816 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rodrigo Andres", LastNames = "CHALLAPA CABEZAS", PersonId = "6210506 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rosa", LastNames = "CONDORI  CONDORI ", PersonId = "6544307 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maria Luisa", LastNames = "ESPINOZA", PersonId = "2865494 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Bernardino", LastNames = "VELA RICALDIS", PersonId = "3796520 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Danitza Griselda", LastNames = "CHOQUE  ORELLANA ", PersonId = "4420243 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juan Carlos", LastNames = "YUGAR IQUISE  ", PersonId = "1765510 PA", Phone = "" });
                //this.Person.Add(new Person() { Names = "Natalio", LastNames = "VILLCA ", PersonId = "550222 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Florinda", LastNames = "MENDOZA ALANES ", PersonId = "5167456 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Sabina", LastNames = "JORA  SANCA ", PersonId = "5287768 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rossio", LastNames = "TERCEROS LUJAN", PersonId = "6495775 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Ana", LastNames = "ESPINDOLA ROMERO", PersonId = "1043344 CH", Phone = "" });
                //this.Person.Add(new Person() { Names = "Felipe", LastNames = "CRESPO MAYTA", PersonId = "4488745 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Luisa", LastNames = "CAERO DE FLORES", PersonId = "4503676 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Marcelino", LastNames = "SANTOS MAMANI", PersonId = "436725 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Teodora", LastNames = "APAZA  TERCEROS ", PersonId = "5901831 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Federico", LastNames = "PARDO BARRIOSS", PersonId = "6460155 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juan Carlos", LastNames = "BLANCO CADIMA", PersonId = "3767640 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Andres", LastNames = "ORELLANA TERRAZAS", PersonId = "3760281 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Dionicio", LastNames = "CAPIONA STRUELEN ", PersonId = "2522259 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Zenobia", LastNames = "TAMBO MOYA ", PersonId = "3815936 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Emiliana", LastNames = "ROJAS DE VIDAL", PersonId = "886488 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Pascuala", LastNames = "LAIME", PersonId = "3706517 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Evarista Laura", LastNames = "CASTILLO", PersonId = "8823606 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Bertha", LastNames = "GUTIERREZ VELIZ", PersonId = "6451809 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Lucas", LastNames = "TORRICO VIA", PersonId = "3608612 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Esperansa", LastNames = "LIQUE APAZA", PersonId = "6502959 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Prudencia", LastNames = "ALACA  CHOQUE  ", PersonId = "2789881 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Daniel", LastNames = "CHECA AJHUACHO", PersonId = "2794421 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Mamerto", LastNames = "POMA MARCA", PersonId = "7885223 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cirilo", LastNames = "GONZALES  TORRICO ", PersonId = "2915172 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Carolina", LastNames = "ESCOBAR", PersonId = "5279432 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Wilber", LastNames = "HINOJOSA  CORDOBA ", PersonId = "4629888 ZC", Phone = "" });
                //this.Person.Add(new Person() { Names = "Bacilio", LastNames = "LOPEZ MENESES", PersonId = "5336327 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Severino", LastNames = "CHOQUE VIDEZ", PersonId = "5253373 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Clemente", LastNames = "PINTADO  QUIROZ ", PersonId = "4481458 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cristina", LastNames = "VASQUEZ ROMERO DE MONTAÑO", PersonId = "9300651 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Pedro", LastNames = "VARGAS  VALLEJOS  ", PersonId = "8046836 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Guillermo", LastNames = "CHARACAYO  CAYARI  ", PersonId = "4107013 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "Wily Elmer", LastNames = "SALAZAR ORELLANA", PersonId = "6418996 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Juvenal", LastNames = "TERRAZAS MENECES", PersonId = "3151597 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Toribio", LastNames = "VARGAS  PINTADO ", PersonId = "6506822 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Eduardo", LastNames = "ALVAREZ", PersonId = "3618199 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Froilan", LastNames = "COCA  PERES ", PersonId = "6465859 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maria Elena", LastNames = "SUNABIA PAUCARA", PersonId = "4910154 LP", Phone = "" });
                //this.Person.Add(new Person() { Names = "Flora", LastNames = "MAMANI DE CRUZ", PersonId = "5308734 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Daniel", LastNames = "ARCOS GUERRA", PersonId = "4427240 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Agustin", LastNames = "TADEO SANDOVAL", PersonId = "6635509 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Tomasina", LastNames = "CONDORI OJEDA", PersonId = "9385332 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Sixto", LastNames = "MAMANI CHAMBI", PersonId = "5519724 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Hilarion", LastNames = "FLORES MAMANI MARCELA GABRIEL", PersonId = "6684286 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Salvador", LastNames = "VASQUEZ CARRASCO", PersonId = "3806899 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Edgar", LastNames = "DURAN  ZEJAS ", PersonId = "6549247 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Cleto", LastNames = "ANDRADE  VILLAROEL ", PersonId = "3800132 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Victoria", LastNames = "VILLCA CUEVAS", PersonId = "4398658 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Zacarias", LastNames = "EIZAGA TRIGO", PersonId = "8440231 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Rene", LastNames = "AGUILAR PANOZO", PersonId = "4419937 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Gualberto", LastNames = "MONTAÑO ALVAREZ", PersonId = "982777 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "MATILDE PATRICIA", LastNames = "SANCHEZ CHOQUE", PersonId = "4051530 OR", Phone = "" });
                //this.Person.Add(new Person() { Names = "David", LastNames = "MOLLE TORREZ", PersonId = "6486757 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Eulogio", LastNames = "TOLA FELIPE", PersonId = "6493935 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Humberto", LastNames = "CRUZ  CAMACHO ", PersonId = "6690731 PT", Phone = "" });
                //this.Person.Add(new Person() { Names = "Celia", LastNames = "CALDERON GARCIA", PersonId = "7950980 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Maximo", LastNames = "JACINTO LEQUE", PersonId = "4438594 CB", Phone = "" });
                //this.Person.Add(new Person() { Names = "Mario", LastNames = "GONSALES CARVALLO", PersonId = "7883189 CB", Phone = "" });

                //SaveChanges();

                //this.Square.Add(new Square() { SquareId = "B1", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B2", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B3", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B4", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B5", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B6", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B7", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B8", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B9", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B10", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B11", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B12", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B13", Comment = "", Enable = true });
                ////this.Square.Add(new Square() { SquareId = "B13", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B14", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B15", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B16", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B17", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B18", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B20", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B21", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B22", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B23", Comment = "", Enable = true });
                //this.Square.Add(new Square() { SquareId = "B24", Comment = "", Enable = true });

                //// lotes faltantes
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "16", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "17", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "26", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "29", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "31", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "32", SquareId = "B1", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "33", SquareId = "B1", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "5", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "8", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "9", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "13", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "16", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "17", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "21", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "22", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "25", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "28", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "31", SquareId = "B2", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "33", SquareId = "B2", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B3", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B3", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "5", SquareId = "B3", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B3", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "8", SquareId = "B3", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B3", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B3", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "B3", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "22", SquareId = "B3", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B3", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "9", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "15", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "18", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "22", SquareId = "B4", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "23", SquareId = "B4", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B5", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B5", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B5", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B5", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B5", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B5", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "13", SquareId = "B5", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B5", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B6", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B6", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "7", SquareId = "B6", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B6", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "13", SquareId = "B6", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "15", SquareId = "B6", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B6", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "25", SquareId = "B6", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "26", SquareId = "B6", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "7", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "8", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "16", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "18", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "25", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "26", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "35", SquareId = "B7", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "39", SquareId = "B7", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "7", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "15", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "18", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "21", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "22", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "23", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "28", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "30", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "35", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "38", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "39", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "40", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "41", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "43", SquareId = "B8", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "44", SquareId = "B8", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "8", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "15", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "16", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "17", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "18", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "25", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "29", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "32", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "33", SquareId = "B9", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "34", SquareId = "B9", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "7", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "13", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "15", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "16", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "17", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "21", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "22", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "23", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "28", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "31", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "32", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "34", SquareId = "B10", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "37", SquareId = "B10", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "9", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "15", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "18", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "22", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "23", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "26", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "30", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "31", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "32", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "33", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "34", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "35", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "36", SquareId = "B11", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "37", SquareId = "B11", Enable = true });



                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "5", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "13", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "15", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "17", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "21", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "22", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "23", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B12", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "27", SquareId = "B12", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "5", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "8", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "17", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "18", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "23", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "25", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "26", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "27", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "31", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "35", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "36", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "37", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "38", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "39", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "40", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "41", SquareId = "B13", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "42", SquareId = "B13", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "5", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "7", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "9", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "15", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "16", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "17", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "18", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "21", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "22", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "26", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "31", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "32", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "33", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "34", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "36", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "37", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "38", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "43", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "47", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "49", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "50", SquareId = "B14", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "51", SquareId = "B14", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "9", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "13", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "21", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "22", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "23", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "25", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "27", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "29", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "31", SquareId = "B15", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "33", SquareId = "B15", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B16", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "8", SquareId = "B16", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B16", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B16", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "17", SquareId = "B16", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "18", SquareId = "B16", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "23", SquareId = "B16", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "25", SquareId = "B16", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "27", SquareId = "B16", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "5", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "7", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "8", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "9", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "13", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "15", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "16", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "B17", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B17", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B18", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B18", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B18", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "5", SquareId = "B18", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "7", SquareId = "B18", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B18", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B20", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B21", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B21", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B21", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B22", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B23", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B23", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B23", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B23", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "7", SquareId = "B23", Enable = true });

                //this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "B24", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B24", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B24", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "B24", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "7", SquareId = "B24", Enable = true });
                //this.Allotment.Add(new Allotment() { AllotmentName = "9", SquareId = "B24", Enable = true });

                //SaveChanges();

                //this.Kardex.Add(new Kardex() { ClientId = "7909322 CB", WaterMeasurer = "A11L342653", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4096605 CH", WaterMeasurer = "A11L381671", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5243655 CB", WaterMeasurer = "A11L282667", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4447889 CB", WaterMeasurer = "A11L341065", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5317593 CB", WaterMeasurer = "A11L282673", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6414994 CB", WaterMeasurer = "A11L282278", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4444514 CB", WaterMeasurer = "A11L282662", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3612299 CB", WaterMeasurer = "A11L342335", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3481755 LP", WaterMeasurer = "A11L282746", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5208273 NCB", WaterMeasurer = "A11L283242", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8018707 CB", WaterMeasurer = "A11L340793", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3573123 CB", WaterMeasurer = "A11L339992", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5295577 CB", WaterMeasurer = "A11L339991", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5256229 CB", WaterMeasurer = "A11L340947", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7964874 CB", WaterMeasurer = "A11L281457", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5260491 CB", WaterMeasurer = "A11L339994", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5553483 PT", WaterMeasurer = "A11L282018", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "9323480 CB", WaterMeasurer = "A11L282751", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4415012 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6443037 CB", WaterMeasurer = "A11L340796", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5301610 CB", WaterMeasurer = "A11L282284", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7881054 CB", WaterMeasurer = "A11L283242", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "982326 CB", WaterMeasurer = "A11L282663", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B1", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "686428 OR", WaterMeasurer = "A11L282522", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7521440 CH", WaterMeasurer = "A11L282521", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4498493 CB", WaterMeasurer = "A11L283241", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3155567 CB", WaterMeasurer = "A11L369624", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4505140 CB", WaterMeasurer = "A11L282525", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5151737 CB", WaterMeasurer = "A11L339998", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4479951 CB", WaterMeasurer = "A11L282286", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3761046 CB", WaterMeasurer = "A11L282743", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6457612 CB", WaterMeasurer = "A11L282739", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5152801 CB", WaterMeasurer = "A11L282674", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6536604 CB", WaterMeasurer = "A11L282281", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5231767 CB", WaterMeasurer = "282277", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5283506 CB", WaterMeasurer = "A11L282740", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3760721 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3547439 OR", WaterMeasurer = "A11L340791", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7948195 CB", WaterMeasurer = "A11L341546", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B2", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "2908036 CB", WaterMeasurer = "A11L341549", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7944542 CB", WaterMeasurer = "A11L341540", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5909062 CB", WaterMeasurer = "A11L342424", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4436615 CB", WaterMeasurer = "A11L342422", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5933096 CB", WaterMeasurer = "A11L282017", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5909590 CB", WaterMeasurer = "A11L281469", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7971798 CB", WaterMeasurer = "A11L281461", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7870820 CB", WaterMeasurer = "A11L341543", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5157742 CB", WaterMeasurer = "A11L339626", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5272938 CB", WaterMeasurer = "A11L283741", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3081925 OR", WaterMeasurer = "A11L282518", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3001920 CB", WaterMeasurer = "A11L282238", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3558299 OR", WaterMeasurer = "A11L283744", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6536646 CB", WaterMeasurer = "A11L283737", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3868468 SC", WaterMeasurer = "A11L282526", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6553725 CB", WaterMeasurer = "A11L283746", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6501681 CB", WaterMeasurer = "A11L282520", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5422479 ZC", WaterMeasurer = "A11L341750", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B3", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "3592998 CB", WaterMeasurer = "A11L283536", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5263361 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3636033 CH", WaterMeasurer = "A11L282752", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6451211 CB", WaterMeasurer = "A11L341547", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3619376 CB", WaterMeasurer = "A11L342429", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4680817 ZC", WaterMeasurer = "A11L339997", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3623573 CB", WaterMeasurer = "A11L342334", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8050961 CB", WaterMeasurer = "A11L282241", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6440839 CB", WaterMeasurer = "A11L284728", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6532314 CB", WaterMeasurer = "A11L282747", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5907166 CB", WaterMeasurer = "A11L341544", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4441716 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B4", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "4532345 CB", WaterMeasurer = "A11L281475", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2396867 LP", WaterMeasurer = "A11L281576", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7968125 CB", WaterMeasurer = "A11L281773", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5273837 CB", WaterMeasurer = "A11L281774", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6543748 CB", WaterMeasurer = "A11L281956", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8047522 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3051916 OR", WaterMeasurer = "A11L282239", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8055388 CB", WaterMeasurer = "A11L282021", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6616059 PT", WaterMeasurer = "A11L282749", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "882271 CB", WaterMeasurer = "A11L342421", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2385367 LP", WaterMeasurer = "A11L341548", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7888302 CB", WaterMeasurer = "A11L281468", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "5259402 CB", WaterMeasurer = "A11L282283", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2901664 CB", WaterMeasurer = "A11L282665", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6529607 CB", WaterMeasurer = "A11L282659", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6412272 CB", WaterMeasurer = "A11L282279", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7947353 CB", WaterMeasurer = "A11L342656", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6522393 CB", WaterMeasurer = "A11L341360", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7882637 CB", WaterMeasurer = "A11L281669", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4380874 CB", WaterMeasurer = "A11L282282", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6534835 CB", WaterMeasurer = "A11L283240", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6478656 CB", WaterMeasurer = "A11L341943", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5504465 PT", WaterMeasurer = "A11L282742", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6665622 PT", WaterMeasurer = "A11L282742", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5128843 PT", WaterMeasurer = "A11L283739", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6633838 PT", WaterMeasurer = "A11L282242", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5317691 CB", WaterMeasurer = "A11L282745", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7998285 CB", WaterMeasurer = "A11L341758", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7892874 CB", WaterMeasurer = "A11L341943", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7987033 CB", WaterMeasurer = "A11L282666", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "976078 CB", WaterMeasurer = "A11L283244", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6551827 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4446344 CB", WaterMeasurer = "A11L282754", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3580589 CB", WaterMeasurer = "A11L282744", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3575890 CB", WaterMeasurer = "A11L340871", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "9373449 CB", WaterMeasurer = "A11L283239", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3593414 CB", WaterMeasurer = "A11L282737", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "896201 CB", WaterMeasurer = "A11L281776", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3751356 CB", WaterMeasurer = "A11L341069", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4536751 CB", WaterMeasurer = "A11L281570", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "731382 CB", WaterMeasurer = "731382", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5116615 PT", WaterMeasurer = "A11L341379", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6402182 CB", WaterMeasurer = "A11L281529", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5262716 CB", WaterMeasurer = "A11L342336", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6442234 CB", WaterMeasurer = "A11L282676", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3615251 CB", WaterMeasurer = "A11L282671", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "737475 CB", WaterMeasurer = "A11L282675", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "842807 CB", WaterMeasurer = "A11L283243", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4427443 CB", WaterMeasurer = "A11L339990", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "902123 CB", WaterMeasurer = "A11L282668", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5215415 CB", WaterMeasurer = "A11L282669", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3614171 CB", WaterMeasurer = "A11L283246", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "33", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5228372 CB", WaterMeasurer = "A11L282672", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3980293 PT", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3569771 CB", WaterMeasurer = "A11L282657", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "37", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5284610 CB", WaterMeasurer = "A11L282660", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "38", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3747690 CB", WaterMeasurer = "A11L339995", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "40", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4473984 CB", WaterMeasurer = "A11L340947", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "41", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5186319 CB", WaterMeasurer = "A11L340948", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "42", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "5213794 CB", WaterMeasurer = "A11L281458", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5204657 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6459422 CB", WaterMeasurer = "A11L282240", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3092974 OR", WaterMeasurer = "A11L342333", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3735339 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4432085 CB", WaterMeasurer = "A11L342426", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5299922 CB", WaterMeasurer = "A11L282523", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4430834 CB", WaterMeasurer = "A11L340949", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4455960 CB", WaterMeasurer = "A11L340943", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "996717 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "851009 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5202817 CB", WaterMeasurer = "A11L341448", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4502879 CB", WaterMeasurer = "A11L281573", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2454533 LP", WaterMeasurer = "A11L281772", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5157622 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3608695 CB", WaterMeasurer = "A11L281672", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "33", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5272704 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3153598 CB", WaterMeasurer = "A11L341751", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8008991 CB", WaterMeasurer = "A11L339999", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "37", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3590418 CB", WaterMeasurer = "A11L283238", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "42", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3050115 OR", WaterMeasurer = "A11L283245", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "45", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "1790035 CB", WaterMeasurer = "A11L283237", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "46", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "654074 OR", WaterMeasurer = "A11L341948", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "47", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5161332 CB", WaterMeasurer = "A11L282756", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "48", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "3538440 OR", WaterMeasurer = "A11L282019", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "10509374 PT", WaterMeasurer = "A11L283740", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5180524 CB", WaterMeasurer = "A11L281465", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5913931 CB", WaterMeasurer = "A11L340792", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3511210 OR", WaterMeasurer = "A11L283535", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3767565 CB", WaterMeasurer = "A11L282389", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4507180 CB", WaterMeasurer = "A11L282524", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2862102 CB", WaterMeasurer = "A11L341063", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3781518 CB", WaterMeasurer = "A11L342423", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2901372 CB", WaterMeasurer = "A11L341067", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4416893 CB", WaterMeasurer = "A11L341541", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4180974 BN", WaterMeasurer = "A11L341542", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6476647 CB", WaterMeasurer = "SIN MEDIDOR  ", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4456985 CB", WaterMeasurer = "A11L341443", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3724998 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5203325 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8797654 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "952214 CB", WaterMeasurer = "A11L341841", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3758959 CB", WaterMeasurer = "A11L341042", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5915261 CB", WaterMeasurer = "A11L282248", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3115024 CB", WaterMeasurer = "A11L283743", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6274341 SC", WaterMeasurer = "A11L341942", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6567130 PT", WaterMeasurer = "A11L281457", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3016800 CB", WaterMeasurer = "A11283742", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2877007 CB", WaterMeasurer = "A11L342420", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "291779 LP", WaterMeasurer = "A11L283745", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5301890 CB", WaterMeasurer = "A11L340942", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4424549 CB", WaterMeasurer = "A11L341725", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6510871 CB", WaterMeasurer = "A11L341725", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6555043 CB", WaterMeasurer = "A11L283527", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4498060 CB", WaterMeasurer = "A11L342659", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5155601 CB", WaterMeasurer = "A11L281460", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5299112 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "33", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4500140 CB", WaterMeasurer = "A11L282244", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6592976 CB", WaterMeasurer = "A11L281466", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4088487 CH", WaterMeasurer = "A11L282391", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "38", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "3752898 CB", WaterMeasurer = "A11L281769", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5309990 CB", WaterMeasurer = "A11L281532", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2156041 LP", WaterMeasurer = "A11L281770", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4522583 CB", WaterMeasurer = "A11L341061", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7889444 CB", WaterMeasurer = "A11L281533", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3801793 CB", WaterMeasurer = "A11L281568", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "979884 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4439515 CB", WaterMeasurer = "A11L34147", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "1130229 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3154190 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3993471 PT", WaterMeasurer = "A11L282390", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3593553 CB", WaterMeasurer = "A11L341946", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2870675 CB", WaterMeasurer = "A11L282243", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4296746 LP", WaterMeasurer = "A11L282237", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7874402 CB", WaterMeasurer = "A11L281954", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8830867 CB", WaterMeasurer = "A11L281470", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4499022 CB.", WaterMeasurer = "A11L283738", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "38", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5238088 CB", WaterMeasurer = "A11L341047", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "39", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4470215 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "40", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4469412 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "41", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3727733 CB", WaterMeasurer = "AL11341827", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "43", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "800519 CB", WaterMeasurer = "A11L281463", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "44", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "4539743 CB", WaterMeasurer = "A11L341444", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5906246 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4508725 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4422419 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7751567 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2915043 CB", WaterMeasurer = "A11L342417", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4398142 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6432505 CB", WaterMeasurer = "A11L283534", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4450813 CB", WaterMeasurer = "A11L341754", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5913598 CB", WaterMeasurer = "A11L281472", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5928900 CB", WaterMeasurer = "A11L341446", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "3992584 PT", WaterMeasurer = "A11L341945", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5259536 CB", WaterMeasurer = "A11L282020", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3796950 CB", WaterMeasurer = "A11L283529", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6428193 CB", WaterMeasurer = "A11L282025", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7910237 CB", WaterMeasurer = "A11L283528", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4455995 CB", WaterMeasurer = "A11L281531", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3799044 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7944418 CB", WaterMeasurer = "A11L282393", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3763124 CB", WaterMeasurer = "A11L339628", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4519770 CB", WaterMeasurer = "A11L281950", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6484641 CB", WaterMeasurer = "A11L282395", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6501790 CB", WaterMeasurer = "A11L282024", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2480980 LP", WaterMeasurer = "A11L341449", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2890383 CB", WaterMeasurer = "A11L342650", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3686303 PT", WaterMeasurer = "A11L282750", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3728130 CB", WaterMeasurer = "A11L340798", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5203333 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3788175 CB", WaterMeasurer = "A11L342651", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "33", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6533504 CB", WaterMeasurer = "A11L3409401", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7861367 CB", WaterMeasurer = "A11L341940", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "43", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "5765721 OR", WaterMeasurer = "A11L282782", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4396468 CB", WaterMeasurer = "A11L341369", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5920051 CB", WaterMeasurer = "A11L341757", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2871974 CB", WaterMeasurer = "A11L281951", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3043728 OR", WaterMeasurer = "A11L281535", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "1436398 PT", WaterMeasurer = "A11L340874", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5259652 CB", WaterMeasurer = "A11L281572", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6435080 CB", WaterMeasurer = "A11L341941", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6421040 CB", WaterMeasurer = "A11L282784", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5535582 CB", WaterMeasurer = "A11L281528", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3506628 OR", WaterMeasurer = "A11L282778", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3222739 ZC", WaterMeasurer = "A11L342337", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5194046 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5927384 CB", WaterMeasurer = "A11L340790", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8672312 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8733899 CB", WaterMeasurer = "A11L281948", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "39", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4498205 CB", WaterMeasurer = "A11L282026", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "40", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3598409 CB", WaterMeasurer = "A11L281530", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "41", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7964805 CB", WaterMeasurer = "A11L283532", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "42", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4474510 CB", WaterMeasurer = "A11L281476", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "44", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3796708 CB", WaterMeasurer = "A11L281574", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "45", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2919500 CB", WaterMeasurer = "A11L281767", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "46", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5234009 CB", WaterMeasurer = "A11L283530", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "48", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4482220 CB", WaterMeasurer = "A11L281567", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "52", SquareId = "B14", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "7936517 CB", WaterMeasurer = "A11L281674", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5208605 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4476739 CB", WaterMeasurer = "A11L341847", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5304816 CB", WaterMeasurer = "A11L282388", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6210506 CB", WaterMeasurer = "A11L281667", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6544307 CB", WaterMeasurer = "A11L282785", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2865494 CB", WaterMeasurer = "A11L340877", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3796520 CB", WaterMeasurer = "A11L281575", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4420243 CB", WaterMeasurer = "A11L281670", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "1765510 PA", WaterMeasurer = "A11L282783", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "550222 OR", WaterMeasurer = "A11L281768", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5167456 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5287768 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6495775 CB", WaterMeasurer = "A11L342338", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "1043344 CH", WaterMeasurer = "A11L341840", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4488745 CB", WaterMeasurer = "A11L281947", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4503676 CB", WaterMeasurer = "A11L341066", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B15", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "436725 LP", WaterMeasurer = "A11L281474", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5901831 CB", WaterMeasurer = "A11L341369", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6460155 CB", WaterMeasurer = "A11L341366", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3767640 CB", WaterMeasurer = "A11L341049", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3760281 CB", WaterMeasurer = "A11L341373", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2522259 LP", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3815936 CB", WaterMeasurer = "A11L341362", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "886488 CB", WaterMeasurer = "A11L341367", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3706517 CB", WaterMeasurer = "A11L341041", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8823606 CB", WaterMeasurer = "A11L341043", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6451809 CB", WaterMeasurer = "A11L341949", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3608612 CB", WaterMeasurer = "A11L341849", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6502959 CB", WaterMeasurer = "A11L282755", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2789881 OR", WaterMeasurer = "A11L282777", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2794421 OR", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7885223 CB", WaterMeasurer = "A11L281673", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "2915172 CB", WaterMeasurer = "A11L281675", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5279432 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4629888 ZC", WaterMeasurer = "A11L341044", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5336327 CB", WaterMeasurer = "A11L281676", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5253373 CB", WaterMeasurer = "A11L341846", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4481458 CB", WaterMeasurer = "A11L341848", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B16", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "9300651 CB", WaterMeasurer = "A11L340876", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B17", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8046836 CB", WaterMeasurer = "A11L341378", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B17", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4107013 OR", WaterMeasurer = "A11L341375", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B17", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6418996 CB", WaterMeasurer = "A11L341363", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B17", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3151597 CB", WaterMeasurer = "A11L341844", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B17", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6506822 CB", WaterMeasurer = "A11L341040", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B17", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "3618199 CB", WaterMeasurer = "A11L339622", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B18", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6465859 CB", WaterMeasurer = "A11L340860", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B18", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4910154 LP", WaterMeasurer = "A11L340873", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B18", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5308734 CB", WaterMeasurer = "A11L341365", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B18", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4427240 CB", WaterMeasurer = "A11L341361", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B18", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "6635509 PT", WaterMeasurer = "A11L342428", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B20", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "9385332 CB", WaterMeasurer = "A11L339625", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B20", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "5519724 CB", WaterMeasurer = "A11L339629", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B20", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6684286 CB", WaterMeasurer = "A11L339621", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B20", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "3806899 CB", WaterMeasurer = "A11L341374", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B21", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6549247 CB", WaterMeasurer = "A11L341944", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B21", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "3800132 CB", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B21", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "4398658 CB", WaterMeasurer = "A11L341370", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B22", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "8440231 CB", WaterMeasurer = "A11L341371", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B22", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4419937 CB", WaterMeasurer = "A11L341377", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B22", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "982777 CB", WaterMeasurer = "A11L342655", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B23", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4051530 OR", WaterMeasurer = "SIN MEDIDOR", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B23", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6486757 CB", WaterMeasurer = "A11L282779", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B23", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "6493935 CB", WaterMeasurer = "A11L340945", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B23", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //this.Kardex.Add(new Kardex() { ClientId = "6690731 PT", WaterMeasurer = "A11282780", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B24", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7950980 CB", WaterMeasurer = "A11282396", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B24", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "4438594 CB", WaterMeasurer = "A11L340799", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B24", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                //this.Kardex.Add(new Kardex() { ClientId = "7883189 CB", WaterMeasurer = "A11282392", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B24", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                //SaveChanges();
                #endregion

                #region Los pinos datos

                this.Square.Add(new Square() { SquareId = "A", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "B", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "C", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "D", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "E", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "F", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "G", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "H", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "I", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "J", Comment = "", Enable = true });
                this.Square.Add(new Square() { SquareId = "K", Comment = "", Enable = true });

                SaveChanges();


                this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "A", Enable = true });

                this.Allotment.Add(new Allotment() { AllotmentName = "10", SquareId = "B", Enable = true });

                this.Allotment.Add(new Allotment() { AllotmentName = "6", SquareId = "C", Enable = true });
                this.Allotment.Add(new Allotment() { AllotmentName = "11", SquareId = "C", Enable = true });

                this.Allotment.Add(new Allotment() { AllotmentName = "1", SquareId = "E", Enable = true });
                this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "E", Enable = true });
                this.Allotment.Add(new Allotment() { AllotmentName = "9", SquareId = "E", Enable = true });

                this.Allotment.Add(new Allotment() { AllotmentName = "14", SquareId = "F", Enable = true });

                this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "I", Enable = true });
                this.Allotment.Add(new Allotment() { AllotmentName = "18", SquareId = "I", Enable = true });
                this.Allotment.Add(new Allotment() { AllotmentName = "19", SquareId = "I", Enable = true });

                this.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "J", Enable = true });
                this.Allotment.Add(new Allotment() { AllotmentName = "13", SquareId = "J", Enable = true });

                this.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "K", Enable = true });

                SaveChanges();

                this.Person.Add(new Person() { Names = "Isabel", LastNames = "Mujica Escobar", PersonId = "642549", Phone = "" });
                this.Person.Add(new Person() { Names = "Santos", LastNames = "Inocente Pardo", PersonId = "3722475", Phone = "" });
                this.Person.Add(new Person() { Names = "Roxana Gimena", LastNames = "Quispe Choque", PersonId = "6512462", Phone = "" });
                this.Person.Add(new Person() { Names = "Cristina", LastNames = "Isnado Mendoza", PersonId = "9322044", Phone = "" });
                this.Person.Add(new Person() { Names = "Carina", LastNames = "Rojas Andia", PersonId = "4506541", Phone = "" });
                this.Person.Add(new Person() { Names = "Bonifacio", LastNames = "Delgadillo Guzman", PersonId = "3797193", Phone = "" });
                this.Person.Add(new Person() { Names = "Ines", LastNames = "Delgadillo Marzana", PersonId = "5262535", Phone = "" });
                this.Person.Add(new Person() { Names = "Juan", LastNames = "Rojas Montaño", PersonId = "4410183", Phone = "" });
                this.Person.Add(new Person() { Names = "Francisca", LastNames = "Garcia Ledezma", PersonId = "3038114", Phone = "" });
                this.Person.Add(new Person() { Names = "Celia", LastNames = "Villarroel Aguilera", PersonId = "3993626", Phone = "" });
                this.Person.Add(new Person() { Names = "Celia", LastNames = "Tumiri Machaca", PersonId = "8960755", Phone = "" });
                this.Person.Add(new Person() { Names = "Emiliano", LastNames = "Herbas Camacho", PersonId = "7682577", Phone = "" });
                this.Person.Add(new Person() { Names = "Aquilino", LastNames = "Herbas Melendres", PersonId = "6476834", Phone = "" });

                this.Person.Add(new Person() { Names = "Conrrado", LastNames = "Veliz Galarza", PersonId = "3140956", Phone = "" });

                this.Person.Add(new Person() { Names = "Ireneo", LastNames = "Peña Villarroel", PersonId = "3139706", Phone = "" });
                this.Person.Add(new Person() { Names = "Saul", LastNames = "Armando Arancibia", PersonId = "6519638", Phone = "" });
                this.Person.Add(new Person() { Names = "Martin", LastNames = "Diaz Parada", PersonId = "6474201", Phone = "" });
                this.Person.Add(new Person() { Names = "Favian", LastNames = "Diaz Parada", PersonId = "7900233", Phone = "" });
                this.Person.Add(new Person() { Names = "Damian", LastNames = "Layme Parada", PersonId = "7949716", Phone = "" });


                this.Person.Add(new Person() { Names = "Remigio", LastNames = "Sejas Cayola", PersonId = "3797208", Phone = "" });
                this.Person.Add(new Person() { Names = "Martin", LastNames = "Felipe Gonzales", PersonId = "4401661", Phone = "" });
                this.Person.Add(new Person() { Names = "Zacarias", LastNames = "Pantoja ", PersonId = "5254737", Phone = "" });
                this.Person.Add(new Person() { Names = "Natividad", LastNames = "Guevara Rojas", PersonId = "5247557", Phone = "" });
                this.Person.Add(new Person() { Names = "Isabel", LastNames = "Prado Ponce", PersonId = "8007823", Phone = "" });
                this.Person.Add(new Person() { Names = "Alfredo", LastNames = "Vallejos Ferrel", PersonId = "8828571", Phone = "" });
                this.Person.Add(new Person() { Names = "Elza", LastNames = "Galindo Zapata", PersonId = "6460243", Phone = "" });
                this.Person.Add(new Person() { Names = "Bladimir", LastNames = "Montaño Temprano", PersonId = "6553848", Phone = "" });
                this.Person.Add(new Person() { Names = "Victor", LastNames = "Gandarillas Quispe", PersonId = "3077474", Phone = "" });

                this.Person.Add(new Person() { Names = "Luordes", LastNames = "Choque Chirilla", PersonId = "4384593", Phone = "" });
                this.Person.Add(new Person() { Names = "Gregorio", LastNames = "Felipe Lima", PersonId = "6134796", Phone = "" });
                this.Person.Add(new Person() { Names = "Pedro", LastNames = "Santos Lopez", PersonId = "3776545", Phone = "" });
                this.Person.Add(new Person() { Names = "Jacinto", LastNames = "Rodriguez Fermin", PersonId = "6458744", Phone = "" });
                this.Person.Add(new Person() { Names = "Alejandro", LastNames = "Delgadillo  ", PersonId = "12464053", Phone = "" });
                this.Person.Add(new Person() { Names = "Margarita", LastNames = "Tarqui Collacopa", PersonId = "4531755", Phone = "" });


                this.Person.Add(new Person() { Names = "Constancio", LastNames = "Guzman Alanes", PersonId = "991090", Phone = "" });
                this.Person.Add(new Person() { Names = "Panfila", LastNames = "Aguilar De Rojas", PersonId = "3796985", Phone = "" });
                this.Person.Add(new Person() { Names = "Cosme", LastNames = "Rivera  Camacho", PersonId = "4499836", Phone = "" });
                this.Person.Add(new Person() { Names = "Luciano", LastNames = "Felipe Flores", PersonId = "6788176", Phone = "" });
                this.Person.Add(new Person() { Names = "Fausto", LastNames = "Rios Mallcu", PersonId = "588632", Phone = "" });

                this.Person.Add(new Person() { Names = "Shan Hebert", LastNames = "Rios Mendoza", PersonId = "3545518", Phone = "" });
                this.Person.Add(new Person() { Names = "Eleuteria", LastNames = "Maria Quispe", PersonId = "2731931", Phone = "" });
                this.Person.Add(new Person() { Names = "Rufino", LastNames = "Marzana Orellana", PersonId = "3796705", Phone = "" });
                this.Person.Add(new Person() { Names = "Martin", LastNames = "Poma Mendoza", PersonId = "5922049", Phone = "" });

                this.Person.Add(new Person() { Names = "Rene", LastNames = "Crespo Tapia", PersonId = "4040797", Phone = "" });
                this.Person.Add(new Person() { Names = "Flaviano", LastNames = "Orellana ", PersonId = "3126708", Phone = "" });
                this.Person.Add(new Person() { Names = "Nancy", LastNames = "Mamani Villarroel", PersonId = "6502490", Phone = "" });
                this.Person.Add(new Person() { Names = "Juan", LastNames = "Escobar Herrera", PersonId = "6423373", Phone = "" });
                this.Person.Add(new Person() { Names = "Ricardo", LastNames = "Escobar Herrera", PersonId = "4478684", Phone = "" });
                this.Person.Add(new Person() { Names = "Fidelia", LastNames = "Herrera De Escobar", PersonId = "882367", Phone = "" });
                this.Person.Add(new Person() { Names = "Cecilia", LastNames = "Choque Mamani", PersonId = "651909", Phone = "" });
                this.Person.Add(new Person() { Names = "Cecilia", LastNames = "Cotrina Hinojosa", PersonId = "901030", Phone = "" });
                this.Person.Add(new Person() { Names = "Pastor", LastNames = "Olivera Vargas", PersonId = "4436363", Phone = "" });
                this.Person.Add(new Person() { Names = "Domitila", LastNames = "Barja Zambrana", PersonId = "6346272", Phone = "" });



                this.Person.Add(new Person() { Names = "Sara", LastNames = "Morales Zapata", PersonId = "9301202", Phone = "" });
                this.Person.Add(new Person() { Names = "Nicomedes", LastNames = "Vallejos Cotrina", PersonId = "3593885", Phone = "" });
                this.Person.Add(new Person() { Names = "Gregorio", LastNames = "Veizaga Cotrina", PersonId = "3005969", Phone = "" });
                this.Person.Add(new Person() { Names = "Aurelio", LastNames = "Veizaga Correa", PersonId = "6522457", Phone = "" });
                this.Person.Add(new Person() { Names = "Encarnacion", LastNames = "Prado Meneces", PersonId = "4396554", Phone = "" });
                this.Person.Add(new Person() { Names = "Alejandro", LastNames = "Correa Sejas", PersonId = "3144155", Phone = "" });
                this.Person.Add(new Person() { Names = "Grover", LastNames = "Meneces Vallejos", PersonId = "7870743", Phone = "" });
                this.Person.Add(new Person() { Names = "Hernando", LastNames = "Cordova Rojas", PersonId = "932008", Phone = "" });
                this.Person.Add(new Person() { Names = "Saul", LastNames = "Vargas Rodriguez", PersonId = "5244416", Phone = "" });
                this.Person.Add(new Person() { Names = "Jose Elmer ", LastNames = "Cordova Vargas", PersonId = "6469460", Phone = "" });





                this.Person.Add(new Person() { Names = "Constantino", LastNames = "Chajmi Copajira", PersonId = "8847404", Phone = "" });
                this.Person.Add(new Person() { Names = "Leonardo", LastNames = "Chajmi Calle", PersonId = "5513458", Phone = "" });
                this.Person.Add(new Person() { Names = "Julia", LastNames = "Vasquez Rocha", PersonId = "4441190", Phone = "" });
                this.Person.Add(new Person() { Names = "Maria", LastNames = "Loza De Abasto", PersonId = "944486", Phone = "" });
                this.Person.Add(new Person() { Names = "Cecilio", LastNames = "Guzman Vasquez", PersonId = "3574393", Phone = "" });
                this.Person.Add(new Person() { Names = "Teofila", LastNames = "Hinojosa Leon", PersonId = "8731604", Phone = "" });

                this.Person.Add(new Person() { Names = "Jorge", LastNames = "Correa Garcia", PersonId = "7930383", Phone = "" });
                this.Person.Add(new Person() { Names = "Juan De Dios", LastNames = "Zapata Escalera", PersonId = "4498980", Phone = "" });
                this.Person.Add(new Person() { Names = "Mario", LastNames = "Veizaga Aviles", PersonId = "6556906", Phone = "" });
                this.Person.Add(new Person() { Names = "Oved", LastNames = "Vargas Romero", PersonId = "5939972", Phone = "" });



                this.Person.Add(new Person() { Names = "Rosalia Rosa", LastNames = "Condori Quispe", PersonId = "5225158", Phone = "" });
                this.Person.Add(new Person() { Names = "Sebastian", LastNames = "Parra ", PersonId = "4498186", Phone = "" });
                this.Person.Add(new Person() { Names = "Antonio", LastNames = "Ignacio Gabriel", PersonId = "5526132", Phone = "" });
                this.Person.Add(new Person() { Names = "Primitivo", LastNames = "Trujillo Veizaga", PersonId = "6424110", Phone = "" });
                this.Person.Add(new Person() { Names = "Esteban", LastNames = "Trujillo Veizaga", PersonId = "7971420", Phone = "" });
                this.Person.Add(new Person() { Names = "Erminia", LastNames = "Fuentes Leon", PersonId = "5268706", Phone = "" });
                this.Person.Add(new Person() { Names = "Fortunata", LastNames = "Rojas Azcarraga", PersonId = "7992025", Phone = "" });
                this.Person.Add(new Person() { Names = "Juana", LastNames = "Garcia Lopez", PersonId = "1963046", Phone = "" });
                this.Person.Add(new Person() { Names = "Ricardo", LastNames = "Llampa Guaygua", PersonId = "4454389", Phone = "" });
                this.Person.Add(new Person() { Names = "German", LastNames = "Llampa Guaygua", PersonId = "5216779", Phone = "" });
                this.Person.Add(new Person() { Names = "Damacio", LastNames = "Orella  Gonzales", PersonId = "5492363", Phone = "" });
                this.Person.Add(new Person() { Names = "Oscar Jesus", LastNames = "Mujica Urquidi", PersonId = "6406365", Phone = "" });
                this.Person.Add(new Person() { Names = "Cipriana", LastNames = "Velarde ", PersonId = "3575737", Phone = "" });

                this.Person.Add(new Person() { Names = "Miguelina", LastNames = "Castellon Parra", PersonId = "6548270", Phone = "" });
                this.Person.Add(new Person() { Names = "Urbano", LastNames = "Claros Blanco", PersonId = "982302", Phone = "" });
                this.Person.Add(new Person() { Names = "Jesus", LastNames = "Ayala ", PersonId = "8736562", Phone = "" });
                this.Person.Add(new Person() { Names = "Isabel", LastNames = "Villagomes Ledezma", PersonId = "8675667", Phone = "" });
                this.Person.Add(new Person() { Names = "Emiliana", LastNames = "Llanque Mamani", PersonId = "8780964", Phone = "" });
                this.Person.Add(new Person() { Names = "Juan Carlos", LastNames = "Mamani Catorceno", PersonId = "6441554", Phone = "" });



                this.Person.Add(new Person() { Names = "Gregorio", LastNames = "Meneces  Meneces", PersonId = "8732569", Phone = "" });
                this.Person.Add(new Person() { Names = "Mirian Roxana", LastNames = "Colque Laime", PersonId = "6503494", Phone = "" });
                this.Person.Add(new Person() { Names = "Marta", LastNames = "Gabriel De Vida", PersonId = "4525700", Phone = "" });
                this.Person.Add(new Person() { Names = "Herman", LastNames = "Colque  Laime", PersonId = "5283724", Phone = "" });
                this.Person.Add(new Person() { Names = "Guillermina", LastNames = "Laime De Colque", PersonId = "5300376", Phone = "" });
                this.Person.Add(new Person() { Names = "Urbana", LastNames = "Veliz Mamani", PersonId = "2894970", Phone = "" });
                this.Person.Add(new Person() { Names = "Luciano", LastNames = "Meneces Meneces", PersonId = "2893458", Phone = "" });
                this.Person.Add(new Person() { Names = "Sonia", LastNames = "Colque Laime", PersonId = "3814804", Phone = "" });
                this.Person.Add(new Person() { Names = "Tomas", LastNames = "Maldonado Vallejos", PersonId = "3769324", Phone = "" });
                this.Person.Add(new Person() { Names = "Juan Luis", LastNames = "Rojas Rios", PersonId = "3805376", Phone = "" });
                this.Person.Add(new Person() { Names = "Paulino", LastNames = "Diaz Parada", PersonId = "5576080", Phone = "" });
                this.Person.Add(new Person() { Names = "Johnny", LastNames = "Ledezma Torrico", PersonId = "3789028", Phone = "" });
                this.Person.Add(new Person() { Names = "Jimena", LastNames = "Lique Nina", PersonId = "9426339", Phone = "" });
                this.Person.Add(new Person() { Names = "Herminia", LastNames = "Quispe Laime", PersonId = "8050337", Phone = "" });
                this.Person.Add(new Person() { Names = "Andres", LastNames = "Quisberth Quispe", PersonId = "3406187", Phone = "" });
                this.Person.Add(new Person() { Names = "Diego", LastNames = "Quisberth Quispe", PersonId = "6007749", Phone = "" });
                this.Person.Add(new Person() { Names = "Rene Freddy", LastNames = "Quispe Laime", PersonId = "5294359", Phone = "" });
                this.Person.Add(new Person() { Names = "Florentino", LastNames = "Meneces Meneces", PersonId = "8784290", Phone = "" });



                this.Person.Add(new Person() { Names = "Guillermo", LastNames = "Catari Choque", PersonId = "646582", Phone = "" });
                this.Person.Add(new Person() { Names = "Ruben", LastNames = "Catari Catari", PersonId = "3532492", Phone = "" });
                this.Person.Add(new Person() { Names = "Lidia", LastNames = "Huaitari Romero", PersonId = "4452813", Phone = "" });
                this.Person.Add(new Person() { Names = "Lucia", LastNames = "Choque Aira", PersonId = "7968767", Phone = "" });
                this.Person.Add(new Person() { Names = "Jose", LastNames = "Condori Nina", PersonId = "2560488", Phone = "" });
                this.Person.Add(new Person() { Names = "Marcelino", LastNames = "Cespedes Cayo", PersonId = "2956103", Phone = "" });
                this.Person.Add(new Person() { Names = "Carmen", LastNames = "Felipe Gonzales", PersonId = "7968851", Phone = "" });
                this.Person.Add(new Person() { Names = "Estela", LastNames = "Chavez ", PersonId = "4498341", Phone = "" });
                this.Person.Add(new Person() { Names = "Elbira Ayda", LastNames = "Patty De Sarzuri", PersonId = "6553175", Phone = "" });
                this.Person.Add(new Person() { Names = "Sinforiano", LastNames = "Soto Reyes", PersonId = "5191253", Phone = "" });
                this.Person.Add(new Person() { Names = "Rudy", LastNames = "Tarqui Felipe", PersonId = "8732418", Phone = "" });
                this.Person.Add(new Person() { Names = "Emetrio", LastNames = "Tarqui Callapata", PersonId = "3573124", Phone = "" });
                this.Person.Add(new Person() { Names = "Sesario", LastNames = "Espinosa Rodriguez", PersonId = "3155331", Phone = "" });



                this.Person.Add(new Person() { Names = "Aleyda", LastNames = "Mamani ", PersonId = "6461167", Phone = "" });

                this.Person.Add(new Person() { Names = "Eugenio", LastNames = "Huiatari Romero", PersonId = "3159019", Phone = "" });
                this.Person.Add(new Person() { Names = "Nely", LastNames = "Huiatari Romero", PersonId = "4433512", Phone = "" });
                this.Person.Add(new Person() { Names = "Alejandrina", LastNames = "Mamani Calisaya", PersonId = "653504", Phone = "" });
                this.Person.Add(new Person() { Names = "Robert Alex", LastNames = "Rioja Vasquez", PersonId = "3771216", Phone = "" });
                this.Person.Add(new Person() { Names = "Jose", LastNames = "Rioja Rojas", PersonId = "759456", Phone = "" });
                this.Person.Add(new Person() { Names = "Felix", LastNames = "Onofre Paniagua", PersonId = "4478609", Phone = "" });
                this.Person.Add(new Person() { Names = "Maria Carmen", LastNames = "Onofre Paniagua", PersonId = "5214418", Phone = "" });
                this.Person.Add(new Person() { Names = "Nelson", LastNames = "Cañoto Carrasco", PersonId = "3565366", Phone = "" });
                this.Person.Add(new Person() { Names = "Genaro", LastNames = "Martinez Gutierrez", PersonId = "3743415", Phone = "" });
                this.Person.Add(new Person() { Names = "Senobia", LastNames = "Reyes Vallejos", PersonId = "3570153", Phone = "" });
                this.Person.Add(new Person() { Names = "Elena", LastNames = "Rioja De Lobo", PersonId = "2913311", Phone = "" });
                this.Person.Add(new Person() { Names = "Eulogio", LastNames = "Quispe  Apaza", PersonId = "382763", Phone = "" });
                this.Person.Add(new Person() { Names = "Arminda", LastNames = "Quezada Laime", PersonId = "5917694", Phone = "" });
                this.Person.Add(new Person() { Names = "Paulino", LastNames = "Mamani Ledezma", PersonId = "8040482", Phone = "" });
                this.Person.Add(new Person() { Names = "Martina", LastNames = "Gabriel Huanaco", PersonId = "5177470", Phone = "" });


                this.Person.Add(new Person() { Names = "Eugenio", LastNames = "Mancilla Calle", PersonId = "6402170", Phone = "" });



                this.Person.Add(new Person() { Names = "Francisca", LastNames = "Gandarillas Veizaga", PersonId = "2899741", Phone = "" });
                this.Person.Add(new Person() { Names = "Jaime", LastNames = "Camacho Gandarillas", PersonId = "6518001", Phone = "" });
                this.Person.Add(new Person() { Names = "Severino", LastNames = "Camacho Flores", PersonId = "2902625", Phone = "" });

                this.Person.Add(new Person() { Names = "Freddy", LastNames = "Camacho Gandarillas", PersonId = "7887742", Phone = "" });
                this.Person.Add(new Person() { Names = "Florencia", LastNames = "Hinojosa Meneces", PersonId = "4465544", Phone = "" });
                this.Person.Add(new Person() { Names = "Niceforo", LastNames = "Soto Jimenes", PersonId = "945715", Phone = "" });
                this.Person.Add(new Person() { Names = "Beatriz", LastNames = "Reyes Vallejos", PersonId = "360472", Phone = "" });
                this.Person.Add(new Person() { Names = "Jorge", LastNames = "Soto Reyes", PersonId = "7761272", Phone = "" });
                this.Person.Add(new Person() { Names = "Dorotea", LastNames = "Llanque Cabrera", PersonId = "8797802", Phone = "" });
                this.Person.Add(new Person() { Names = "Ramiro", LastNames = "Gandarillas ", PersonId = "5228056", Phone = "" });
                this.Person.Add(new Person() { Names = "Rafael", LastNames = "Soto  Reyes", PersonId = "5215639", Phone = "" });

                this.Person.Add(new Person() { Names = "Santiago", LastNames = "Guevara  Vallejos", PersonId = "6477248", Phone = "" });



                this.Person.Add(new Person() { Names = "Victor", LastNames = "Humacacho Choque", PersonId = "852809", Phone = "" });

                this.Person.Add(new Person() { Names = "Aide Lizeth", LastNames = "Espinosa Jimenez", PersonId = "5914508", Phone = "" });
                this.Person.Add(new Person() { Names = "Florencio", LastNames = "Navia Jaldin", PersonId = "978737", Phone = "" });
                this.Person.Add(new Person() { Names = "Maria", LastNames = "Isabel Chavez", PersonId = "5748770", Phone = "" });
                this.Person.Add(new Person() { Names = "Mauricio Luis", LastNames = "Canqui Chavez", PersonId = "6555052", Phone = "" });
                this.Person.Add(new Person() { Names = "Fresia", LastNames = "Condori Escobar", PersonId = "6471514", Phone = "" });
                this.Person.Add(new Person() { Names = "Erlinda", LastNames = "Navia Atocha", PersonId = "6542583", Phone = "" });
                this.Person.Add(new Person() { Names = "Emigdio", LastNames = "Merida Urive", PersonId = "8740444", Phone = "" });
                this.Person.Add(new Person() { Names = "Nieves", LastNames = "Delgadillo  Duran", PersonId = "8019479", Phone = "" });
                this.Person.Add(new Person() { Names = "Cupertino", LastNames = "Delgadillo Guzman", PersonId = "9355265", Phone = "" });
                this.Person.Add(new Person() { Names = "Jhonilda", LastNames = "Paredes La Fuente", PersonId = "5237915", Phone = "" });
                this.Person.Add(new Person() { Names = "Nora", LastNames = "Velasquez Garcia", PersonId = "7899789", Phone = "" });
                this.Person.Add(new Person() { Names = "Demetrio", LastNames = "Orosco Zapata", PersonId = "3585726", Phone = "" });
                this.Person.Add(new Person() { Names = "Casiano", LastNames = "Zeballos Meneces", PersonId = "5252547", Phone = "" });
                this.Person.Add(new Person() { Names = "Eleuterio", LastNames = "Lazarte Orosco", PersonId = "5291961", Phone = "" });
                this.Person.Add(new Person() { Names = "Sixto", LastNames = "Mamani Lazaro", PersonId = "7869186", Phone = "" });


                SaveChanges();

                this.Kardex.Add(new Kardex() { ClientId = "642549", WaterMeasurer = "317423", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3722475", WaterMeasurer = "53713", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6512462", WaterMeasurer = "53712", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "9322044", WaterMeasurer = "53715", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4506541", WaterMeasurer = "317425", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3797193", WaterMeasurer = "53711", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5262535", WaterMeasurer = "317123", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4410183", WaterMeasurer = "317424", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3038114", WaterMeasurer = "317428", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3993626", WaterMeasurer = "317422", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8960755", WaterMeasurer = "53720", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7682577", WaterMeasurer = "53719", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6476834", WaterMeasurer = "53714", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "3140956", WaterMeasurer = "53718", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "3139706", WaterMeasurer = "127907", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6519638", WaterMeasurer = "53622", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6474201", WaterMeasurer = "53717", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7900233", WaterMeasurer = "127909", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7949716", WaterMeasurer = "127906", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "A", Enable = true } }, Enable = true, HasAWaterMeasurer = false });


                this.Kardex.Add(new Kardex() { ClientId = "3797208", WaterMeasurer = "52666", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4401661", WaterMeasurer = "53530", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5254737", WaterMeasurer = "53528", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5247557", WaterMeasurer = "127903", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8007823", WaterMeasurer = "535597", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8828571", WaterMeasurer = "53529", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6460243", WaterMeasurer = "317420", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6553848", WaterMeasurer = "53527", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3077474", WaterMeasurer = "317125", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "4384593", WaterMeasurer = "127901", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6134796", WaterMeasurer = "127905", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3776545", WaterMeasurer = "127908", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6458744", WaterMeasurer = "127904", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "12464053", WaterMeasurer = "53526", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4531755", WaterMeasurer = "127900", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B", Enable = true } }, Enable = true, HasAWaterMeasurer = false });


                this.Kardex.Add(new Kardex() { ClientId = "991090", WaterMeasurer = "53524", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3796985", WaterMeasurer = "317122", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4499836", WaterMeasurer = "53521", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6788176", WaterMeasurer = "18058", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "588632", WaterMeasurer = "317256", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "3545518", WaterMeasurer = "317419", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "2731931", WaterMeasurer = "291539", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3796705", WaterMeasurer = "127902", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5922049", WaterMeasurer = "18057", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "4040797", WaterMeasurer = "317427", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3126708", WaterMeasurer = "317126", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6502490", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6423373", WaterMeasurer = "317196", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4478684", WaterMeasurer = "53505", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "882367", WaterMeasurer = "53510", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "651909", WaterMeasurer = "291541", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "901030", WaterMeasurer = "316669", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4436363", WaterMeasurer = "18059", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6346272", WaterMeasurer = "18056", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "C", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "9301202", WaterMeasurer = "317118", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3593885", WaterMeasurer = "317175", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3005969", WaterMeasurer = "53623", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6522457", WaterMeasurer = "53624", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4396554", WaterMeasurer = "53625", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3144155", WaterMeasurer = "317127", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7870743", WaterMeasurer = "316673", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "932008", WaterMeasurer = "317192", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5244416", WaterMeasurer = "317193", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6469460", WaterMeasurer = "317195", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "D", Enable = true } }, Enable = true, HasAWaterMeasurer = false });





                this.Kardex.Add(new Kardex() { ClientId = "8847404", WaterMeasurer = "317421", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5513458", WaterMeasurer = "317255", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4441190", WaterMeasurer = "18524", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "944486", WaterMeasurer = "316672", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3574393", WaterMeasurer = "317121", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8731604", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "7930383", WaterMeasurer = "317191", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4498980", WaterMeasurer = "317190", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6556906", WaterMeasurer = "53501", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5939972", WaterMeasurer = "317198", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "E", Enable = true } }, Enable = true, HasAWaterMeasurer = false });



                this.Kardex.Add(new Kardex() { ClientId = "5225158", WaterMeasurer = "316670", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4498186", WaterMeasurer = "18523", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5526132", WaterMeasurer = "202728", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6424110", WaterMeasurer = "18525", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7971420", WaterMeasurer = "18521", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5268706", WaterMeasurer = "53504", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7992025", WaterMeasurer = "18530", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "1963046", WaterMeasurer = "18522", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4454389", WaterMeasurer = "18527", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5216779", WaterMeasurer = "53629", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5492363", WaterMeasurer = "53502", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6406365", WaterMeasurer = "53506", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3575737", WaterMeasurer = "53503", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "6548270", WaterMeasurer = "53630", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "982302", WaterMeasurer = "53626", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8736562", WaterMeasurer = "18526", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8675667", WaterMeasurer = "18081", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8780964", WaterMeasurer = "18529", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6441554", WaterMeasurer = "53595", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "F", Enable = true } }, Enable = true, HasAWaterMeasurer = false });



                this.Kardex.Add(new Kardex() { ClientId = "8732569", WaterMeasurer = "18529", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6503494", WaterMeasurer = "317378", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4525700", WaterMeasurer = "317772", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5283724", WaterMeasurer = "317370", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5300376", WaterMeasurer = "317371", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "2894970", WaterMeasurer = "53593", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "2893458", WaterMeasurer = "53621", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3814804", WaterMeasurer = "317369", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3769324", WaterMeasurer = "53592", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3805376", WaterMeasurer = "317128", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5576080", WaterMeasurer = "18084", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3789028", WaterMeasurer = "317374", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "9426339", WaterMeasurer = "317426", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8050337", WaterMeasurer = "317376", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3406187", WaterMeasurer = "53594", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6007749", WaterMeasurer = "18083", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5294359", WaterMeasurer = "3137377", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8784290", WaterMeasurer = "53600", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "G", Enable = true } }, Enable = true, HasAWaterMeasurer = false });



                this.Kardex.Add(new Kardex() { ClientId = "646582", WaterMeasurer = "317254", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3532492", WaterMeasurer = "317258", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4452813", WaterMeasurer = "317249", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7968767", WaterMeasurer = "53599", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "2560488", WaterMeasurer = "53598", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "2956103", WaterMeasurer = "317124", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7968851", WaterMeasurer = "316678", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4498341", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6553175", WaterMeasurer = "53596", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5191253", WaterMeasurer = "53591", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8732418", WaterMeasurer = "317373", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3573124", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3155331", WaterMeasurer = "317194", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "H", Enable = true } }, Enable = true, HasAWaterMeasurer = false });



                this.Kardex.Add(new Kardex() { ClientId = "6461167", WaterMeasurer = "18052", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "3159019", WaterMeasurer = "317257", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4433512", WaterMeasurer = "317250", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "653504", WaterMeasurer = "52667", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3771216", WaterMeasurer = "52668", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "759456", WaterMeasurer = "18051", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4478609", WaterMeasurer = "18086", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5214418", WaterMeasurer = "18089", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3565366", WaterMeasurer = "18085", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3743415", WaterMeasurer = "316671", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3570153", WaterMeasurer = "52665", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "2913311", WaterMeasurer = "52664", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "382763", WaterMeasurer = "52669", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5917694", WaterMeasurer = "53507", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8040482", WaterMeasurer = "18088", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5177470", WaterMeasurer = "202736", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });


                this.Kardex.Add(new Kardex() { ClientId = "6402170", WaterMeasurer = "53628", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "I", Enable = true } }, Enable = true, HasAWaterMeasurer = false });



                this.Kardex.Add(new Kardex() { ClientId = "2899741", WaterMeasurer = "18053", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6518001", WaterMeasurer = "53765", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "2902625", WaterMeasurer = "52663", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "7887742", WaterMeasurer = "18060", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "4465544", WaterMeasurer = "317189", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "945715", WaterMeasurer = "52661", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "360472", WaterMeasurer = "18054", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7761272", WaterMeasurer = "18055", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8797802", WaterMeasurer = "52662", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5228056", WaterMeasurer = "52670", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5215639", WaterMeasurer = "317120", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "6477248", WaterMeasurer = "18090", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "J", Enable = true } }, Enable = true, HasAWaterMeasurer = false });



                this.Kardex.Add(new Kardex() { ClientId = "852809", WaterMeasurer = "53627", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                this.Kardex.Add(new Kardex() { ClientId = "5914508", WaterMeasurer = "53764", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "978737", WaterMeasurer = "53761", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5748770", WaterMeasurer = "291538", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6555052", WaterMeasurer = "53762", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6471514", WaterMeasurer = "53525", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "6542583", WaterMeasurer = "291537", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8740444", WaterMeasurer = "53766", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "8019479", WaterMeasurer = "317197", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "9355265", WaterMeasurer = "317252", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5237915", WaterMeasurer = "53763", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7899789", WaterMeasurer = "317251", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "3585726", WaterMeasurer = "53508", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5252547", WaterMeasurer = "18087", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "5291961", WaterMeasurer = "53503", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
                this.Kardex.Add(new Kardex() { ClientId = "7869186", WaterMeasurer = "202729", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "K", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

                SaveChanges();
                #endregion

            }
        }

        public static WFPEntities Instance
        {
            get
            {
                if (instance == null)
                {
                    instance = new WFPEntities();
                }
                return instance;
            }
        }

        public override int SaveChanges()
        {
            int result = base.SaveChanges();
            instance = new WFPEntities();
            return result;
        }

        public DbSet<OtherCollectControl> OtherCollectControls { get; set; }
        public DbSet<CollectControl> CollectsControls { get; set; }
        public DbSet<Model.WaterReadingControl> WaterReadingControl { get; set; }
        public DbSet<Model.WaterCollectControl> WaterCollectControl { get; set; }
        public DbSet<Model.WaterPurchase> WaterSupply { get; set; }
        public DbSet<Model.FineCollectControl> FineCollectControl { get; set; }
        public DbSet<Model.CutSupply> CutSupply { get; set; }
        public DbSet<Model.Allotment> Allotment { get; set; }
        public DbSet<Model.Cistern> Cistern { get; set; }
        public DbSet<Model.Kardex> Kardex { get; set; }
        public DbSet<Model.Person> Person { get; set; }
        public DbSet<Model.Square> Square { get; set; }
        public DbSet<Model.Expense> Spend { get; set; }
        public DbSet<Model.User> User { get; set; }
        public DbSet<Model.FeesAndFines> FeesAndFines { get; set; }
        public DbSet<Model.OtbData> OtbData { get; set; }
        public DbSet<Model.Payment> Payment { get; set; }
        public DbSet<Model.Meeting> Meeting { get; set; }
        public DbSet<Model.Assistance> Assistance { get; set; }
        public DbSet<Model.Reconnection> Reconnections { get; set; }
        public DbSet<Model.AppConfiguration> Configurations { get; set; }


        public void DiscardChanges()
        {
            instance = new WFPEntities();
        }
    }
}
